


** SCRUB
destring UNIVERSAL_BUILDING_SQUARE_FEET, replace
destring TOTAL_VALUE_CALCULATED , replace
destring ASSD_TOTAL_VALUE , replace
destring MKT_TOTAL_VALUE , replace
destring APPR_TOTAL_VALUE, replace
destring LAND_VALUE_CALCULATED, replace
destring ASSD_LAND_VALUE, replace
destring TAX_AMOUNT, replace
destring LAND_SQUARE_FOOTAGE, replace 
destring FRONT_FOOTAGE , replace
destring DEPTH_FOOTAGE, replace
destring ACRES, replace

** ROOMS
rename TOTAL_ROOMS rooms
label var rooms "No. Rooms"

** PROPERTY_INDICATOR_CODE: tells you condo, sf, duplex 
destring PROPERTY_INDICATOR_CODE, replace  /* this says 10 - sf, 11, condo, 21, duplex */

** SQUARE FEET
gen temp2 = UNIVERSAL_BUILDING_SQUARE_FEET/1000
drop UNIVERSAL_BUILDING_SQUARE_FEET
rename temp2 sqfeet
label var sqfeet "Sq Ft"
replace sqfeet = . if sqfeet==0 | sqfeet==999

** BATHS
gen temp3 = TOTAL_BATHS_CALCULATED/100
drop TOTAL_BATHS_CALCULATED
rename temp3 baths
label var baths "No. Baths"

